



ALTER    function fn_get_process_flow_by_product_id (@product_id int)
returns  @fn_result Table(ProcessStep_ID bigint, 
			PS_Type varchar(20), 
			Process_Type_Name varchar(20))

As
begin
	declare @process_step_id bigint

	set @process_step_id = (select ProcessStep_ID from Product where Product_ID = @product_id) 

	insert @fn_result select *from fn_get_process_flow_by_id(@process_step_id)
	return
end 




